from .exts import db

"""
模型，存放数据库相关
"""


class Students(db.Model):
    __tablename__ = "students"
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    s_id = db.Column(db.String(15), unique=True)  # 学号
    name = db.Column(db.String(15))  # 姓名
    age = db.Column(db.Integer)  # 年龄
    _java = db.Column(db.Integer)  # java成绩
    _python = db.Column(db.Integer)  # python成绩
    _mysql = db.Column(db.Integer)  # mysql成绩
    score = db.Column(db.Integer)  # 总分
